<?php

namespace common\components\office\grid;

use Yii;
use Closure;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use yii\data\ArrayDataProvider;
use yii\db\ActiveQueryInterface;
use yii\helpers\ArrayHelper;
use yii\helpers\Inflector;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Cell\DataValidation;
use PhpOffice\PhpSpreadsheet\Style\Protection;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

/**
 * DataColumn is the default column type for the [[GridView]] widget.
 *
 * A simple data column definition refers to an attribute in the data model of the
 * GridView's data provider. The name of the attribute is specified by [[attribute]].
 *
 * By setting [[value]] and [[label]], the header and cell content can be customized.
 *
 * A data column differentiates between the [[getDataCellValue|data cell value]] and the
 * [[renderDataCellContent|data cell content]]. The cell value is an un-formatted value that
 * may be used for calculation, while the actual cell content is a [[format|formatted]] version of that
 * value which may contain HTML markup.
 *
 * For more details and usage information on DataColumn, see the [guide article on data widgets](guide:output-data-widgets).
 *
 * @author Qiang Xue <qiang.xue@gmail.com>
 * @since 2.0
 */
class DataColumn extends Column {

    /**
     * @var string the attribute name associated with this column. When neither [[content]] nor [[value]]
     * is specified, the value of the specified attribute will be retrieved from each data model and displayed.
     *
     * Also, if [[label]] is not specified, the label associated with the attribute will be displayed.
     */
    public $attribute;

    /**
     * @var string label to be displayed in the [[header|header cell]] and also to be used as the sorting
     * link label when sorting is enabled for this column.
     * If it is not set and the models provided by the GridViews data provider are instances
     * of [[\yii\db\ActiveRecord]], the label will be determined using [[\yii\db\ActiveRecord::getAttributeLabel()]].
     * Otherwise [[\yii\helpers\Inflector::camel2words()]] will be used to get a label.
     */
    public $label;

    /**
     * @var string|Closure an anonymous function or a string that is used to determine the value to display in the current column.
     *
     * If this is an anonymous function, it will be called for each row and the return value will be used as the value to
     * display for every data model. The signature of this function should be: `function ($model, $key, $index, $column)`.
     * Where `$model`, `$key`, and `$index` refer to the model, key and index of the row currently being rendered
     * and `$column` is a reference to the [[DataColumn]] object.
     *
     * If this is not set, `$model[$attribute]` will be used to obtain the value, where `$attribute` is the value of [[attribute]].
     */
    public $value;

    /**
     * @var string|array|Closure in which format should the value of each data model be displayed as (e.g. `"raw"`, `"text"`, `"html"`,
     * `['date', 'php:Y-m-d']`). Supported formats are determined by the [[GridView::formatter|formatter]] used by
     * the [[GridView]]. Default format is "text" which will format the value as an HTML-encoded plain text when
     * [[\yii\i18n\Formatter]] is used as the [[GridView::$formatter|formatter]] of the GridView.
     * @see \yii\i18n\Formatter::format()
     */
    public $format = 'text';

    /**
     * @var string|array|Closure in which format should the value of each data model be displayed as (e.g. `"raw"`, `"text"`, `"html"`,
     * `['date', 'php:Y-m-d']`). Supported formats are determined by the [[GridView::formatter|formatter]] used by
     * the [[GridView]]. Default format is "text" which will format the value as an HTML-encoded plain text when
     * [[\yii\i18n\Formatter]] is used as the [[GridView::$formatter|formatter]] of the GridView.
     * @see \yii\i18n\Formatter::format()
     */
    public $unlock = true;

    /**
     * Renders the cell dateType.
     */
    public $borderSeparation = false;

    /**
     * @var string|array|Closure in which format should the value of each data model be displayed as (e.g. `"raw"`, `"text"`, `"html"`,
     * `['date', 'php:Y-m-d']`). Supported formats are determined by the [[GridView::formatter|formatter]] used by
     * the [[GridView]]. Default format is "text" which will format the value as an HTML-encoded plain text when
     * [[\yii\i18n\Formatter]] is used as the [[GridView::$formatter|formatter]] of the GridView.
     * @see DataValidation
     */
    public $dataValidationType;

    /**
     * Renders the cell dateType.
     */
    public $cellDataType;

    /**
     * {@inheritdoc}
     */
    protected function renderHeaderCellContent() {
        if ($this->header !== null || $this->label === null && $this->attribute === null) {
            return parent::renderHeaderCellContent();
        }
        return $this->getHeaderCellLabel();
    }

    /**
     * {@inheritdoc}
     * @since 2.0.8
     */
    protected function getHeaderCellLabel() {
        $provider = $this->grid->dataProvider;
        if ($this->label === null) {
            if ($provider instanceof ActiveDataProvider && $provider->query instanceof ActiveQueryInterface) {
                /* @var $modelClass Model */
                $modelClass = $provider->query->modelClass;
                $model = $modelClass::instance();
                $label = $model->getAttributeLabel($this->attribute);
            } elseif ($provider instanceof ArrayDataProvider && $provider->modelClass !== null) {
                /* @var $modelClass Model */
                $modelClass = $provider->modelClass;
                $model = $modelClass::instance();
                $label = $model->getAttributeLabel($this->attribute);
            } else {
                $models = $provider->getModels();
                if (($model = reset($models)) instanceof Model) {
                    /* @var $model Model */
                    $label = $model->getAttributeLabel($this->attribute);
                } else {
                    $label = Inflector::camel2words($this->attribute);
                }
            }
        } else {
            $label = $this->label;
        }

        return $label;
    }

    /**
     * Returns the data cell value.
     * @param mixed $model the data model
     * @param mixed $key the key associated with the data model
     * @param int $index the zero-based index of the data model among the models array returned by [[GridView::dataProvider]].
     * @return string the data cell value
     */
    public function getDataCellValue($model, $key, $index) {
        if ($this->value !== null) {
            if (is_string($this->value)) {
                return ArrayHelper::getValue($model, $this->value);
            }
            return call_user_func($this->value, $model, $key, $index, $this);
        } elseif ($this->attribute !== null) {
            return ArrayHelper::getValue($model, $this->attribute);
        }
        return null;
    }

    /**
     * {@inheritdoc}
     */
    protected function renderDataCellContent($model, $key, $index) {
        if ($this->content === null) {
            return $this->grid->formatter->format($this->getDataCellValue($model, $key, $index), $this->format);
        }
        return parent::renderDataCellContent($model, $key, $index);
    }

    /**
     * Renders a data cell.
     * @param mixed $model the data model being rendered
     * @param mixed $key the key associated with the data model
     * @param int $index the zero-based index of the data item among the item array returned by [[GridView::dataProvider]].
     * @return string the rendering result
     */
    public function renderSheetCell($text, $sheet, $colIndex, $rowIndex) {
        $cell = $sheet->getCellByColumnAndRow($colIndex, $rowIndex);
        $cellDataType = $this->getOfficeCellDataType();
        if ($cellDataType !== null) {
            $cell->setValueExplicit($text, $cellDataType);
        } else {
            $cell->setValue($text);
        }
        $this->setCellDataValidation($cell);
        $contentOptions = $this->contentOptions;
        $cellStyle = $sheet->getStyleByColumnAndRow($colIndex, $rowIndex);

        $unlock = ArrayHelper::remove($contentOptions, 'unlock', $this->unlock);
        if ($this->grid->protection && is_bool($unlock)) {
            $cellStyle->getProtection()->setLocked($unlock ? Protection::PROTECTION_UNPROTECTED : Protection::PROTECTION_PROTECTED);
        }

        $cellFormatCode = $this->getOfficeCellFormatCode();
        if ($cellFormatCode !== null) {
            $cellStyle->getNumberFormat()->setFormatCode($cellFormatCode);
        }
        if (!empty($contentOptions)) {
            $cellStyle->applyFromArray($contentOptions);
        }

// 要进行锁定的列
//        $objSheet->protectCells('A1：B1', 'paaaword');
// 不用锁定的列 （这句不写的话，未锁定的列也会无法修改）
//        $objSheet->getStyle('A2：B2')->getProtection()->setLocked(\PHPExcel_Style_Protection::PROTECTION_UNPROTECTED);
// 给工作表设置锁定状态 （这句不写的话 上面的都不会生效）
//        $objSheet->getProtection()->setSheet(true);
    }

    /**
     * {@inheritdoc}
     */
    public function setCellDataValidation($cell) {
//            PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT
    }

    /**
     * {@inheritdoc}
     */
    public function setColumnCellDataValidation($spreadsheet) {
        
    }

    /**
     * 
     */
    public function getOfficeCellDataType() {
        $types = [
            // Data types
            'text' => DataType::TYPE_STRING2,
            'integer' => DataType::TYPE_NUMERIC,
            'decimal' => DataType::TYPE_NUMERIC,
            'double' => DataType::TYPE_FORMULA,
//            'text' => DataType::TYPE_STRING,
//            'text' => DataType::TYPE_FORMULA,
//            'text' => DataType::TYPE_NUMERIC,
            'boolean' => DataType::TYPE_BOOL,
//            'text' => DataType::TYPE_NULL,
//            'text' => DataType::TYPE_INLINE,
//            'text' => DataType::TYPE_ERROR,
        ];
        return ArrayHelper::getValue($types, $this->format);
    }

    /**
     * 
     */
    public function getOfficeCellFormatCode() {
        $types = [
            'text' => NumberFormat::FORMAT_TEXT,
            'integer' => NumberFormat::FORMAT_NUMBER,
            'decimal' => NumberFormat::FORMAT_NUMBER_00,
            'double' => NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED2,
        ];
        return ArrayHelper::getValue($types, $this->format);
    }

}
